<?php session_start(); ?>
<?php include "libfunc.php";?>
<?php if (!empty($_SESSION['admUser']) && !empty($_SESSION['admPass'])) { ?>
<html>
 <head>
  <title>.: Admin Room ClothingCorp :.</title>
  <link href="admInc/cssMainStyle.css" type="text/css" rel="stylesheet">
  <link href="admInc/cssTableStyle.css" type="text/css" rel="stylesheet">
  <link href="admInc/cssAdditionStyle.css" type="text/css" rel="stylesheet">
  <link href="admInc/cssTableNavigation.css" type="text/css" rel="stylesheet">
 </head>
 <body class="fix">
  <div id="wrapper">
   <div id="header">
    <div class="titleHeader"><center>
     <img src="image/logo2.png" border="0">
	</div><!-- titleHeader //-->
	<div class="subTitleHeader"><center>
	 - Website Administrator Control Panel -
	</div><!-- subTitleHeader //-->
   </div><!-- header //--></center>
   <div id="mainContent">
    <div id="leftColumn">
	 <div class="navigation">
	  <table border="0" width="100%" bgcolor="white">
	  <tr>
	    <td class="headerTable" align="center"><b>Admin Page</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="adminLayout.php"> Halaman Utama</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="newInformation.php"> Informasi Terkini</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="LogOut.php" onClick="return confirm('Apakah Anda benar-benar akan keluar dari halaman Admin ?')"> Keluar</a></td>
	  </tr>
	  <tr>
	    <td></td>
	  </tr>
	  <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Kategori</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="tambah_kategori.php"> Tambah Kategori</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_kategori.php"> View Kategori</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_kategori.php"> Pencarian Kategori</a></td>
	  </tr>
<br>
      <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Member</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="tambah_member.php"> Tambah Member</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_member.php"> View Member</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_member.php"> Pencarian Member</a></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Produk</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_produk.php"> View Produk</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_produk.php"> Pencarian Produk</a></td>
	  </tr>
	  <tr>
		<td></td>
	  </tr>
	  <tr>
		<td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Penjual</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="tambah_pejual.php"> Tambah Penjual</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_penjual.php"> View Penjual</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_penjual.php"> Pencarian Penjual</a></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	  <tr>
		<td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Pesanan</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_pesanan.php"> View Pesanan</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_pesanan.php"> Pencarian Pesanan</a></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	  
	</table>
	 </div><!-- navigation //-->
	</div><!-- leftColumn //-->
	<div id="rightColumn">
	 <div class="content">
	  <?php 
		  $file   = "view_produk.php";
		  include "class_paging.php";
		  $p      = new Paging;
		  $batas  = 5;
		  $posisi = $p->cariPosisi($batas);
		
		  $link = koneksi_db();
		  $sql  = "select * from produk limit $posisi,$batas";
		  $res  = mysql_query($sql,$link);
		  $sql2 = "select * from produk";
		  $res2 =  mysql_query($sql2);
		  $jmlrecord = mysql_num_rows($res2);
		  $jmlhalaman = $p->jumlahHalaman($jmlrecord,$batas);
		
		if($jmlrecord > 0){
		?>
         <fieldset>
          <legend>View Data Produk</legend>
		   <table align='center' class="tableView">
		    <tr class="trTable">
		     <td>No</td>
		   	 <td>Judul</td>
			 <td>Deskripsi</td>
			 <td>Penjual</td>
			 <td>Harga</td>
			 <td>Stok</td>
			 <td>Detail</td>
		    </tr>
	  <?php
		error_reporting(0);
	     $no = $posisi+1;
		 while( $data = mysql_fetch_array($res) ){
		   ?>
		    <tr>
		     <td><?php echo $no; ?></td>
			 <td><?php echo $data['judul']; ?></td>
			 <td>
			   <?php
			     $sql_p = "select produk.deskripsi from penjual,produk
				 		    where penjual.id_penjual = produk.id_penjual
							and
							produk.deskripsi = '$data[deskripsi]'
							";
				 $query_p = mysql_query($sql_p,$link);
				 $hasil_p = mysql_fetch_array($query_p);
				 
				 echo $hasil_p['deskripsi'];
			   ?>
             </td>
			 <td>
			   <?php 
			   	  $sql_k = "select penjual.nama from penjual,produk
				 		    where penjual.id_penjual = produk.id_penjual
							and
							produk.deskripsi = '$data[deskripsi]'
							";
				  $query_k = mysql_query($sql_k,$link);
				  $hasil_k = mysql_fetch_array($query_k);
					
				 echo $hasil_k['nama'];
			   ?>
             </td>
			 
			 <td>
			   <?php 
			   	  $sql_k = "select produk.harga from penjual,produk
				 		    where penjual.id_penjual = produk.id_penjual
							and
							produk.deskripsi = '$data[deskripsi]'
							";
				  $query_k = mysql_query($sql_k,$link);
				  $hasil_k = mysql_fetch_array($query_k);
					
				 echo $hasil_k['harga'];
			   ?>
             </td>
			 <td>
			   <?php 
			   	  $sql_k = "select produk.stok from penjual,produk
				 		    where penjual.id_penjual = produk.id_penjual
							and
							produk.deskripsi = '$data[deskripsi]'
							";
				  $query_k = mysql_query($sql_k,$link);
				  $hasil_k = mysql_fetch_array($query_k);
					
				 echo $hasil_k['stok'];
			   ?>
             </td>
			 
			 <td align="center"><a href="detail_produk.php?id=<?php echo $data['id_produk']; ?>"><img src="image/magnifier.png" border="0" title="Lihat !"></a></td>
            </tr>
		 <?php
		    $no++;
		 }?>
           </table><br><br>
         <span class="paging">
      <?php
	    $linkHalaman = $p->navHalaman($_GET[halaman],$jmlhalaman);
		echo $linkHalaman;
	  ?>
      	</span>
		 </fieldset>
         <div id='keterangan'>
       	 <fieldset>
          <legend>Keterangan</legend>
         	Data Produk,,Silakan Dilihat !!!
       	  </fieldset>
     	 </div>
         <?php
	  }else{
	    echo "
		  </table>
		 </fieldset>
         <div id='keterangan'>
       		<fieldset>
         	<legend>Keterangan</legend>
         	Data Produk Kosong, Silakan Isi Terlebih Dahulu!!
       		</fieldset>
     	 </div>
		";
	  }
	  ?>
	  </div><!-- content //-->
	</div><!-- rightColumn //-->
   </div><!-- mainContent //-->
  </div><!-- wrapper //-->
 </body>
</html>
<?php
}else{
  echo "<script language='javascript'>alert('Silakan Sign In Terlebih Dahulu')</script>";
  echo "<script language='javascript'>window.location = '../admin/'</script>";
}